USE AdventureWorks2008
GO
EXEC AddTerritory 1, 3, 'Asia';
EXEC AddTerritory 1, 4, 'Middle East and North Africa';
EXEC AddTerritory 1, 5, 'Australia';
EXEC AddTerritory 1, 6, 'Central and South America';
EXEC AddTerritory 1, 7, 'Europe' ;

EXEC AddTerritory 3, 111, 'China' ;
EXEC AddTerritory 3, 112, 'Japan' ;
EXEC AddTerritory 2, 101, 'Canada' ;
EXEC AddTerritory 2, 102, 'Southeast US' ;
EXEC AddTerritory 2, 103, 'Southwest US' ;
EXEC AddTerritory 2, 104, 'Northeast US' ;
EXEC AddTerritory 2, 105, 'Norhtwest US' ;
EXEC AddTerritory 2, 106, 'Central US' ;
EXEC AddTerritory 7, 107, 'France' ;
EXEC AddTerritory 7, 108, 'Great Britain' ;
EXEC AddTerritory 7, 109, 'Germany' ;
EXEC AddTerritory 7, 110, 'Russia' ;